Comparative Study of Column Oriented NoSQL Databases on Characteristics

NoSQL database, also called Not Only SQL, is an approach to data management and database design that's useful for very large sets of distributed data. The growing popularity of big data will compel many companies to use NoSQL databases instead of traditional database. Generally, there are three main types of NoSQL databases: key-value stores, column oriented databases and document based stores. Because the column oriented databases have specific characteristics and advantages compared to others, we decided to introduce the various popular column based NoSQL databases and explain their properties and functionalities. In this paper, we evaluate and compare six popular column oriented NoSQL databases. These databases are compared by CAP theorem, their persistence, concurrency controls and replication opportunities. In addition, this paper classifies NoSQL databases according to the CAP theorem. Finally, the column based NoSQL databases are separately described in detail, and extract some properties in a table to help enterprises to choose NoSQL.